package com.usian.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.usian.pojo.Yuan;
import com.usian.vo.YuanVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

import java.util.List;

@Mapper
public interface YuanMapper extends BaseMapper<Yuan>{

    @Select("select y.*,d.`name` dname,p.`name` pname from deop d,postion p,yuan y where d.id=y.bu and p.id=y.zhi")
    public List<YuanVo> find();



}
